<?xml version="1.0" ?>

<xsl:stylesheet   xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
						xmlns:lzc="http://schemas.icitadel.com/Lazarus/Compiled.xsd"
                  version="1.0">

   <xsl:output method="text"/>

	<xsl:include href="../../common.xsl" />
	<xsl:include href="../../convert.xsl" />
   
   <xsl:template match="lzc:project">
<xsl:text>/*
	Creates empty shells for all stored procedures.
*/

SET ANSI_NULLS ON 
GO

</xsl:text>

		<xsl:apply-templates select="lzc:tables/lzc:table/lzc:methods/lzc:method" />

SET ANSI_NULLS OFF
GO   
	</xsl:template>

   <xsl:template match="lzc:method">
		<xsl:text>CREATE PROCEDURE sp</xsl:text>
		<xsl:value-of select="@db-name" />
		<xsl:text> AS 
GO		

</xsl:text>
		
   </xsl:template>

</xsl:stylesheet>